package jpa.entitys.promis.common;

import java.io.Serializable;

import javax.persistence.*;

import java.math.BigDecimal;
import java.util.Date;


/**
 * The persistent class for the VW_SYNC_FURNITURE_TAX database table.
 * 
 */
@Entity
@Table(name="VW_SYNC_FURNITURE_TAX")
@NamedQueries({
    @NamedQuery(name = "VwSyncFurnitureTax.findAll", query = " SELECT c FROM VwSyncFurnitureTax c "),
    @NamedQuery(name = "VwSyncFurnitureTax.findById", query = " SELECT c FROM VwSyncFurnitureTax c WHERE c.xfrOfOwnershipId = :Id "),
    @NamedQuery(name = "VwSyncFurnitureTax.findByStatus", query = " SELECT c FROM VwSyncFurnitureTax c WHERE c.status = :status And c.syncIsstaging = :syncIsstaging "),
    @NamedQuery(name = "VwSyncFurnitureTax.findByDocumentNo", query = " SELECT c FROM VwSyncFurnitureTax c WHERE c.company = :company And c.project =:project And c.contractRefNo = :contractRefNo And c.status = :status And c.syncIsstaging = :syncIsstaging")
})
public class VwSyncFurnitureTax extends jpa.entitys.common.CommonEntity implements Serializable {
	private static final long serialVersionUID = 1L;

	@Id
	@Column(name="XFR_OF_OWNERSHIP_ID", length=4000)
	private String xfrOfOwnershipId;
	
	@Override public String toString() { return org.apache.commons.lang.builder.ToStringBuilder.reflectionToString(this);}
	
	@Column(name="BUILDING_PHASE_CODE", nullable=false, length=30)
	private String buildingPhaseCode;

	@Column(nullable=false, length=2)
	private String company;

	@Column(name="CONTRACT_NUMBER", nullable=false, precision=6)
	private Long contractNumber;

	@Column(name="CONTRACT_REF_NO", length=4000)
	private String contractRefNo;
	
	@Column(name="REVISION_NUMBER")
	private Long revisionNumber;

	@Column(name="CONTRACT_SERIES", nullable=false, length=4)
	private String contractSeries;

	@Column(name="CREATED_BY")
	private String createdBy;

	@Column(name="CREATED_BY_NAME", length=4000)
	private String createdByName;

    @Temporal( TemporalType.TIMESTAMP)
	@Column(name="CREATED_ON")
	private Date createdOn;

	@Column(length=3)
	private String currency;

	@Column(name="CUSTOMER_CODE", nullable=false, length=30)
	private String customerCode;

	@Column(length=4000)
	private String description;

	@Column(name="EXCHANGE_RATE", precision=22)
	private BigDecimal exchangeRate;

	@Column(name="FLOOR_ZONE_CODE", nullable=false, length=30)
	private String floorZoneCode;

	@Column(name="FURNITURE_AMOUNT", precision=16, scale=2)
	private BigDecimal furnitureAmount;

	@Column(name="FURNITURE_CHARGE_CODE", length=5)
	private String furnitureChargeCode;

	@Column(name="INTERFACE_NO", length=4000)
	private String interfaceNo;

	@Column(name="LAST_UPD_BY_NAME", length=4000)
	private String lastUpdByName;

	@Column(name="LAST_UPDATED_BY")
	private String lastUpdatedBy;

    @Temporal( TemporalType.TIMESTAMP)
	@Column(name="LAST_UPDATED_ON")
	private Date lastUpdatedOn;

	@Column(length=500)
	private String narration;

	@Column(nullable=false, length=30)
	private String project;

	@Column(name="PROJECT_NAME", length=4000)
	private String projectName;

	@Column(name="SAP_COMPANY_CODE", length=4000)
	private String sapCompanyCode;

	@Column(name="SAP_PLANT_CODE", length=4000)
	private String sapPlantCode;

	@Column(length=1)
	private String status;

	@Column(name="SYNC_CREATEDBY", length=100)
	private String syncCreatedby;

    @Temporal( TemporalType.TIMESTAMP)
	@Column(name="SYNC_CREATEDON")
	private Date syncCreatedon;

	@Column(name="SYNC_EXTERNAL_REF_KEY", length=100)
	private String syncExternalRefKey;

	@Column(name="SYNC_EXTERNAL_REF_NO", length=100)
	private String syncExternalRefNo;

	@Column(name="SYNC_ISSTAGING", length=1)
	private String syncIsstaging;

	@Column(name="SYNC_ISSYNC", length=1)
	private String syncIssync;

	@Column(name="SYNC_UPDATEDBY", length=100)
	private String syncUpdatedby;

    @Temporal( TemporalType.TIMESTAMP)
	@Column(name="SYNC_UPDATEDON")
	private Date syncUpdatedon;

	@Column(name="TYPE_OF_CONTRACT", nullable=false, length=2)
	private String typeOfContract;

	@Column(name="UNIT_NUMBER", nullable=false, length=30)
	private String unitNumber;

    @Temporal( TemporalType.TIMESTAMP)
	@Column(name="VOUCHER_DATE")
	private Date voucherDate;
    
    
    
    /**
	 * @return the revisionNumber
	 */
	public Long getRevisionNumber() {
		return revisionNumber;
	}

	/**
	 * @param revisionNumber the revisionNumber to set
	 */
	public void setRevisionNumber(Long revisionNumber) {
		this.revisionNumber = revisionNumber;
	}

	public VwSyncFurnitureTax() {
    }

	public String getBuildingPhaseCode() {
		return this.buildingPhaseCode;
	}

	public void setBuildingPhaseCode(String buildingPhaseCode) {
		this.buildingPhaseCode = buildingPhaseCode;
	}

	public String getCompany() {
		return this.company;
	}

	public void setCompany(String company) {
		this.company = company;
	}

	public Long getContractNumber() {
		return this.contractNumber;
	}

	public void setContractNumber(Long contractNumber) {
		this.contractNumber = contractNumber;
	}

	public String getContractRefNo() {
		return this.contractRefNo;
	}

	public void setContractRefNo(String contractRefNo) {
		this.contractRefNo = contractRefNo;
	}

	public String getContractSeries() {
		return this.contractSeries;
	}

	public void setContractSeries(String contractSeries) {
		this.contractSeries = contractSeries;
	}

	public String getCreatedBy() {
		return this.createdBy;
	}

	public void setCreatedBy(String createdBy) {
		this.createdBy = createdBy;
	}

	public String getCreatedByName() {
		return this.createdByName;
	}

	public void setCreatedByName(String createdByName) {
		this.createdByName = createdByName;
	}

	public Date getCreatedOn() {
		return this.createdOn;
	}

	public void setCreatedOn(Date createdOn) {
		this.createdOn = createdOn;
	}

	public String getCurrency() {
		return this.currency;
	}

	public void setCurrency(String currency) {
		this.currency = currency;
	}

	public String getCustomerCode() {
		return this.customerCode;
	}

	public void setCustomerCode(String customerCode) {
		this.customerCode = customerCode;
	}

	public String getDescription() {
		return this.description;
	}

	public void setDescription(String description) {
		this.description = description;
	}

	public BigDecimal getExchangeRate() {
		return this.exchangeRate;
	}

	public void setExchangeRate(BigDecimal exchangeRate) {
		this.exchangeRate = exchangeRate;
	}

	public String getFloorZoneCode() {
		return this.floorZoneCode;
	}

	public void setFloorZoneCode(String floorZoneCode) {
		this.floorZoneCode = floorZoneCode;
	}

	public BigDecimal getFurnitureAmount() {
		return this.furnitureAmount;
	}

	public void setFurnitureAmount(BigDecimal furnitureAmount) {
		this.furnitureAmount = furnitureAmount;
	}

	public String getFurnitureChargeCode() {
		return this.furnitureChargeCode;
	}

	public void setFurnitureChargeCode(String furnitureChargeCode) {
		this.furnitureChargeCode = furnitureChargeCode;
	}

	public String getInterfaceNo() {
		return this.interfaceNo;
	}

	public void setInterfaceNo(String interfaceNo) {
		this.interfaceNo = interfaceNo;
	}

	public String getLastUpdByName() {
		return this.lastUpdByName;
	}

	public void setLastUpdByName(String lastUpdByName) {
		this.lastUpdByName = lastUpdByName;
	}

	public String getLastUpdatedBy() {
		return this.lastUpdatedBy;
	}

	public void setLastUpdatedBy(String lastUpdatedBy) {
		this.lastUpdatedBy = lastUpdatedBy;
	}

	public Date getLastUpdatedOn() {
		return this.lastUpdatedOn;
	}

	public void setLastUpdatedOn(Date lastUpdatedOn) {
		this.lastUpdatedOn = lastUpdatedOn;
	}

	public String getNarration() {
		return this.narration;
	}

	public void setNarration(String narration) {
		this.narration = narration;
	}

	public String getProject() {
		return this.project;
	}

	public void setProject(String project) {
		this.project = project;
	}

	public String getProjectName() {
		return this.projectName;
	}

	public void setProjectName(String projectName) {
		this.projectName = projectName;
	}

	public String getSapCompanyCode() {
		return this.sapCompanyCode;
	}

	public void setSapCompanyCode(String sapCompanyCode) {
		this.sapCompanyCode = sapCompanyCode;
	}

	public String getSapPlantCode() {
		return this.sapPlantCode;
	}

	public void setSapPlantCode(String sapPlantCode) {
		this.sapPlantCode = sapPlantCode;
	}

	public String getStatus() {
		return this.status;
	}

	public void setStatus(String status) {
		this.status = status;
	}

	public String getSyncCreatedby() {
		return this.syncCreatedby;
	}

	public void setSyncCreatedby(String syncCreatedby) {
		this.syncCreatedby = syncCreatedby;
	}

	public Date getSyncCreatedon() {
		return this.syncCreatedon;
	}

	public void setSyncCreatedon(Date syncCreatedon) {
		this.syncCreatedon = syncCreatedon;
	}

	public String getSyncExternalRefKey() {
		return this.syncExternalRefKey;
	}

	public void setSyncExternalRefKey(String syncExternalRefKey) {
		this.syncExternalRefKey = syncExternalRefKey;
	}

	public String getSyncExternalRefNo() {
		return this.syncExternalRefNo;
	}

	public void setSyncExternalRefNo(String syncExternalRefNo) {
		this.syncExternalRefNo = syncExternalRefNo;
	}

	public String getSyncIsstaging() {
		return this.syncIsstaging;
	}

	public void setSyncIsstaging(String syncIsstaging) {
		this.syncIsstaging = syncIsstaging;
	}

	public String getSyncIssync() {
		return this.syncIssync;
	}

	public void setSyncIssync(String syncIssync) {
		this.syncIssync = syncIssync;
	}

	public String getSyncUpdatedby() {
		return this.syncUpdatedby;
	}

	public void setSyncUpdatedby(String syncUpdatedby) {
		this.syncUpdatedby = syncUpdatedby;
	}

	public Date getSyncUpdatedon() {
		return this.syncUpdatedon;
	}

	public void setSyncUpdatedon(Date syncUpdatedon) {
		this.syncUpdatedon = syncUpdatedon;
	}

	public String getTypeOfContract() {
		return this.typeOfContract;
	}

	public void setTypeOfContract(String typeOfContract) {
		this.typeOfContract = typeOfContract;
	}

	public String getUnitNumber() {
		return this.unitNumber;
	}

	public void setUnitNumber(String unitNumber) {
		this.unitNumber = unitNumber;
	}

	public Date getVoucherDate() {
		return this.voucherDate;
	}

	public void setVoucherDate(Date voucherDate) {
		this.voucherDate = voucherDate;
	}

	public String getXfrOfOwnershipId() {
		return this.xfrOfOwnershipId;
	}

	public void setXfrOfOwnershipId(String xfrOfOwnershipId) {
		this.xfrOfOwnershipId = xfrOfOwnershipId;
	}

}